Failover of Logical Replication Slots in PostgreSQL

Postgresql logical replication slots: Are they 'expensive'? Is having postgres create logical replication slot Drops a replication slot, freeing any reserved server-side resources If the slot is a logical slot that was created in a database other than the database the postgres replication slot You must monitor logical decoding Any unused replication slot must be dropped Slots hold on to Postgres WAL logs and relevant system catalogs

postgresql replication slot restart_lsn will also be moved forward if possible For a physical replication slot, this function updates restart_lsn Share